package com.zhs.gccs.model;

import org.xutils.db.annotation.Column;
import org.xutils.db.annotation.Table;

import java.io.Serializable;
import java.util.List;

//
//select a.xmdm,a.xmbm,a.XMJDID as 'xmjdid',a.xmmc,a.nf,a.xzqhdm,d.lbmc,b.path ,b.name
//        from p_xmk_all a,fu_sys_file b ,s_xx_fjxx c,s_pz_fjjbcsmx d
//        where  b.id=c.fjid and c.ywid=a.xmdm and c.fjmxid=d.dbid and d.tenant_id='000000'  and ifnull(isbxjd,0)<>2
//        and a.xzqhdm in ('420682')  and nf in(2019,2020,2021,2022,2023)
//        ORDER BY a.xmmc
//
//        -- 荆州区421003    老河口420682
@Table(name = "attachments2")
public class Attachment implements Serializable {
    @Column(name = "id",isId = true,autoGen = false)
    private Long id;
    @Column(name = "pid")
    private Long pid;
    @Column(name = "type")
    private Integer type;
    public static final int type_dir = 1;
    public static final int type_file = 2;
    @Column(name = "download")
    private Integer download;//0 1:已下载
    @Column(name = "xmdm")
    private String xmdm;
    @Column(name = "xmjdid")
    private String xmjdid;
    @Column(name = "xmjdmc")
    private String xmjdmc;//项目阶段名称
    @Column(name = "xmmc")
    private String xmmc;
    @Column(name = "nf")
    private String nf;
    @Column(name = "xzqhdm")
    private String xzqhdm;
    @Column(name = "lbmc")
    private String lbmc;//文件类别
    @Column(name = "path")
    private String path;
    @Column(name = "name")
    private String name;
    @Column(name = "province")
    private String province;
    @Column(name = "province_code")
    private String provinceCode;
    @Column(name = "city")
    private String city;
    @Column(name = "city_code")
    private String cityCode;
    @Column(name = "district")
    private String district;
    @Column(name = "district_code")
    private String districtCode;

    /** 是否转换  0：不转化   1：转化 */
    @Column(name = "converted")
    private Integer converted;
    /** 转化后的类型 */
    @Column(name = "converted_type")
    private String convertedType;
    @Column(name = "converted_name")
    private String convertedName;

    @Column(name = "file")
    private byte[] file;

    private List<Attachment> children;


    public Integer getConverted() {
        return converted;
    }

    public void setConverted(Integer converted) {
        this.converted = converted;
    }

    public String getConvertedType() {
        return convertedType;
    }

    public void setConvertedType(String convertedType) {
        this.convertedType = convertedType;
    }

    public String getConvertedName() {
        return convertedName;
    }

    public void setConvertedName(String convertedName) {
        this.convertedName = convertedName;
    }

    public Integer getDownload() {
        return download;
    }

    public void setDownload(Integer download) {
        this.download = download;
    }

    public List<Attachment> getChildren() {
        return children;
    }

    public void setChildren(List<Attachment> children) {
        this.children = children;
    }

    public Long getPid() {
        return pid;
    }

    public void setPid(Long pid) {
        this.pid = pid;
    }

    public Integer getType() {
        return type;
    }

    public void setType(Integer type) {
        this.type = type;
    }

    public Long getId() {
        return id;
    }

    public void setId(Long id) {
        this.id = id;
    }

    public byte[] getFile() {
        return file;
    }

    public void setFile(byte[] file) {
        this.file = file;
    }

    public String getProvince() {
        return province;
    }

    public void setProvince(String province) {
        this.province = province;
    }

    public String getProvinceCode() {
        return provinceCode;
    }

    public void setProvinceCode(String provinceCode) {
        this.provinceCode = provinceCode;
    }

    public String getCity() {
        return city;
    }

    public void setCity(String city) {
        this.city = city;
    }

    public String getCityCode() {
        return cityCode;
    }

    public void setCityCode(String cityCode) {
        this.cityCode = cityCode;
    }

    public String getDistrict() {
        return district;
    }

    public void setDistrict(String district) {
        this.district = district;
    }

    public String getDistrictCode() {
        return districtCode;
    }

    public void setDistrictCode(String districtCode) {
        this.districtCode = districtCode;
    }

    public String getXmjdmc() {
        return xmjdmc;
    }

    public void setXmjdmc(String xmjdmc) {
        this.xmjdmc = xmjdmc;
    }

    public String getLbmc() {
        return lbmc;
    }

    public void setLbmc(String lbmc) {
        this.lbmc = lbmc;
    }

    public String getXmdm() {
        return xmdm;
    }

    public void setXmdm(String xmdm) {
        this.xmdm = xmdm;
    }

    public String getXmjdid() {
        return xmjdid;
    }

    public void setXmjdid(String xmjdid) {
        this.xmjdid = xmjdid;
    }

    public String getXmmc() {
        return xmmc;
    }

    public void setXmmc(String xmmc) {
        this.xmmc = xmmc;
    }

    public String getNf() {
        return nf;
    }

    public void setNf(String nf) {
        this.nf = nf;
    }

    public String getXzqhdm() {
        return xzqhdm;
    }

    public void setXzqhdm(String xzqhdm) {
        this.xzqhdm = xzqhdm;
    }

    public String getPath() {
        return path;
    }

    public void setPath(String path) {
        this.path = path;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }
}
